<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" dir="ltr" lang="en"><head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="Content-Style-Type" content="text/css">
		<meta name="generator" content="MediaWiki 1.15.5">
		<meta name="keywords" content="zh-cn:数据库描述,Administration Panels,Appearance Widgets SubPanel,Comments Comments SubPanel,Create A Network,Database Description,Database Description/2.0,Database Description/2.2,Database Description/2.3,Database Description/2.5,Database Description/2.7">
		<link rel="shortcut icon" href="http://codex.wordpress.org/favicon.ico">
		<link rel="search" type="application/opensearchdescription+xml" href="http://codex.wordpress.org/opensearch_desc.php" title="Codex (en)">
		<link rel="alternate" type="application/rss+xml" title="Codex RSS feed" href="http://codex.wordpress.org/index.php?title=Special:RecentChanges&amp;feed=rss">
		<link rel="alternate" type="application/atom+xml" title="Codex Atom feed" href="http://codex.wordpress.org/index.php?title=Special:RecentChanges&amp;feed=atom">
<title>zh-cn:数据库描述 « WordPress Codex</title>
<style type="text/css">
@import url("http://s.wordpress.org/style/codex-wp4.css?3");
@import url("http://s.wordpress.org/style/wp4.css?10");
</style>
<link media="only screen and (max-device-width: 480px)" href="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/iphone.css" type="text/css" rel="stylesheet">
<!--[if IE]>
<style type="text/css">
@import url("http://wordpress.org/style/ie.css?9");
</style>
<![endif]-->
<link rel="shortcut icon" href="http://s.wordpress.org/favicon.ico" type="image/x-icon">

<script async="" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/cbgapi.loaded0"></script><script gapi_processed="true" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/plusone.js" async="" type="text/javascript"></script><script src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/urchin.js" type="text/javascript"></script>
<script type="text/javascript">
_uacct = "UA-52447-1";
urchinTracker();
</script>

<!--[if IE]>
    <script type="text/javascript" src="/skins/common/IEFixes.js"></script>
    <meta http-equiv="imagetoolbar" content="no" />
<![endif]-->

<script type="text/javascript" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/index.php"></script>
<script type="text/javascript">wgBreakFrames=false;wgContentLanguage='en';</script>
<script type="text/javascript" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/wikibits.js"></script>

<script type="text/javascript" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/jquery.js"></script>
</head>
<body id="wordpress-org">

<div id="header">
	<div class="wrapper">
		<h1><a href="http://wordpress.org/" title="WordPress">WordPress.org</a></h1>

		<form action="http://wordpress.org/search/do-search.php" method="get" id="head-search">
			<input class="text" name="search" value="Search the Codex" maxlength="150" onfocus="this.value=(this.value=='Search the Codex') ? '' : this.value;" onblur="this.value=(this.value=='') ? 'Search the Codex' : this.value;" type="text"> <input class="button" value="Go" type="submit">
		</form>

		<ul>
			<li><a href="http://wordpress.org/" title="Home is where the heart is.">Home</a></li>
			<li><a href="http://wordpress.org/showcase/" title="See some of the sites built on WordPress.">Showcase</a></li>
			<li><a href="http://wordpress.org/extend/" title="Taking WordPress beyond your wildest imagination">Extend</a>
			<ul class="nav-submenu">
				<li><a href="http://wordpress.org/extend/plugins/" title="Plugins can extend WordPress to do almost anything you can imagine.">Plugins</a></li>
				<li><a href="http://wordpress.org/extend/themes/" title="Find just the right look for your website.">Themes</a></li>
			</ul></li>
			<li><a href="http://wordpress.org/about/" title="About the WordPress Organization, and where we're going.">About</a></li>
			<li><a class="current" href="http://codex.wordpress.org/Main_Page" title="Documentation, tutorials, best practices.">Docs</a></li>
			<li><a href="http://wordpress.org/development/" title="Come here for the latest scoop.">Blog</a></li>
			<li><a href="http://wordpress.org/support/" title="Support and discussion forums.">Forums</a></li>
			<li><a href="http://wordpress.org/hosting/" title="Find a home for your blog">Hosting</a></li>
			<li id="download"><a href="http://wordpress.org/download/" title="Get it. Got it? Good.">Download</a></li>
		</ul>
	</div>
</div>

<div id="headline">
	<div class="wrapper">
		<h2>Codex</h2>
		
		<div class="portlet" id="p-personal">
		  <p class="login">Codex tools:
		     <a href="http://codex.wordpress.org/index.php?title=Special:UserLogin&amp;returnto=zh-cn:%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0">Log in</a> 		  </p>
		</div>
	</div>
</div>

<div id="pagebody">
	<div class="wrapper">	
		<div class="col-10" id="bodyContent">
						<h2 class="pagetitle">zh-cn:数据库描述</h2>
									<!-- start content -->
				<p class="LanguageLinks" style="border:1px solid #CCCCCC; line-height:1.5; text-align:left; color:#333333; font-size:90%; padding:10px;"><span style="white-space:nowrap;"><a href="http://codex.wordpress.org/Multilingual_Codex" title="Multilingual Codex" class="mw-redirect">Languages</a>:</span> 
<a href="http://codex.wordpress.org/Database_Description" title="Database Description">English</a> • 
<strong class="selflink">中文(简体)</strong> • 
<a href="http://wpdocs.sourceforge.jp/%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E6%A6%82%E8%A6%81" class="external text" title="http://wpdocs.sourceforge.jp/%E3%83%87%E3%83%BC%E3%82%BF%E3%83%99%E3%83%BC%E3%82%B9%E6%A6%82%E8%A6%81">日本語</a> • 
 <small>(<a href="http://codex.wordpress.org/Multilingual_Codex#Language_Cross_Reference" title="Multilingual Codex" class="mw-redirect">Add your language</a>)</small>
</p>
<table id="toc" class="toc" summary="Contents"><tbody><tr><td><div id="toctitle"><h2>Contents</h2> <span class="toctoggle">[<a href="javascript:toggleToc()" class="internal" id="togglelink">hide</a>]</span></div>
<ul>
<li class="toclevel-1"><a href="#.E6.95.B0.E6.8D.AE.E5.BA.93.E5.9B.BE.E8.A1.A8"><span class="tocnumber">1</span> <span class="toctext">数据库图表</span></a></li>
<li class="toclevel-1"><a href="#.E8.A1.A8.E6.A6.82.E8.BF.B0"><span class="tocnumber">2</span> <span class="toctext">表概述</span></a></li>
<li class="toclevel-1"><a href="#.E8.A1.A8.E8.AF.A6.E7.BB.86.E8.B5.84.E6.96.99"><span class="tocnumber">3</span> <span class="toctext">表详细资料</span></a>
<ul>
<li class="toclevel-2"><a href="#Table:_wp_commentmeta"><span class="tocnumber">3.1</span> <span class="toctext">Table: wp_commentmeta</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes"><span class="tocnumber">3.1.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_comments"><span class="tocnumber">3.2</span> <span class="toctext">Table: wp_comments</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_2"><span class="tocnumber">3.2.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_links"><span class="tocnumber">3.3</span> <span class="toctext">Table: wp_links</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_3"><span class="tocnumber">3.3.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_options"><span class="tocnumber">3.4</span> <span class="toctext">Table: wp_options</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_4"><span class="tocnumber">3.4.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_postmeta"><span class="tocnumber">3.5</span> <span class="toctext">Table: wp_postmeta</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_5"><span class="tocnumber">3.5.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_posts"><span class="tocnumber">3.6</span> <span class="toctext">Table: wp_posts</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_6"><span class="tocnumber">3.6.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_terms"><span class="tocnumber">3.7</span> <span class="toctext">Table: wp_terms</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_7"><span class="tocnumber">3.7.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_term_relationships"><span class="tocnumber">3.8</span> <span class="toctext">Table: wp_term_relationships</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_8"><span class="tocnumber">3.8.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_term_taxonomy"><span class="tocnumber">3.9</span> <span class="toctext">Table: wp_term_taxonomy</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_9"><span class="tocnumber">3.9.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_usermeta"><span class="tocnumber">3.10</span> <span class="toctext">Table: wp_usermeta</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_10"><span class="tocnumber">3.10.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#Table:_wp_users"><span class="tocnumber">3.11</span> <span class="toctext">Table: wp_users</span></a>
<ul>
<li class="toclevel-3"><a href="#Indexes_11"><span class="tocnumber">3.11.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-2"><a href="#.E5.A4.9A.E7.AB.99.E7.82.B9.E8.A1.A8.E6.A6.82.E8.BF.B0"><span class="tocnumber">3.12</span> <span class="toctext">多站点表概述</span></a></li>
<li class="toclevel-2"><a href="#.E5.A4.9A.E7.AB.99.E7.82.B9.E8.A1.A8.E8.AF.A6.E7.BB.86.E8.B5.84.E6.96.99"><span class="tocnumber">3.13</span> <span class="toctext">多站点表详细资料</span></a>
<ul>
<li class="toclevel-3"><a href="#Table:_wp_blogs"><span class="tocnumber">3.13.1</span> <span class="toctext">Table: wp_blogs</span></a>
<ul>
<li class="toclevel-4"><a href="#Indexes_12"><span class="tocnumber">3.13.1.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-3"><a href="#Table:_wp_blog_versions"><span class="tocnumber">3.13.2</span> <span class="toctext">Table: wp_blog_versions</span></a>
<ul>
<li class="toclevel-4"><a href="#Indexes_13"><span class="tocnumber">3.13.2.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-3"><a href="#Table:_wp_registration_log"><span class="tocnumber">3.13.3</span> <span class="toctext">Table: wp_registration_log</span></a>
<ul>
<li class="toclevel-4"><a href="#Indexes_14"><span class="tocnumber">3.13.3.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-3"><a href="#Table:_wp_signups"><span class="tocnumber">3.13.4</span> <span class="toctext">Table: wp_signups</span></a>
<ul>
<li class="toclevel-4"><a href="#Indexes_15"><span class="tocnumber">3.13.4.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-3"><a href="#Table:_wp_site"><span class="tocnumber">3.13.5</span> <span class="toctext">Table: wp_site</span></a>
<ul>
<li class="toclevel-4"><a href="#Indexes_16"><span class="tocnumber">3.13.5.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-3"><a href="#Table:_wp_sitecategories"><span class="tocnumber">3.13.6</span> <span class="toctext">Table: wp_sitecategories</span></a>
<ul>
<li class="toclevel-4"><a href="#Indexes_17"><span class="tocnumber">3.13.6.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-3"><a href="#Table:_wp_sitemeta"><span class="tocnumber">3.13.7</span> <span class="toctext">Table: wp_sitemeta</span></a>
<ul>
<li class="toclevel-4"><a href="#Indexes_18"><span class="tocnumber">3.13.7.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-3"><a href="#Table:_wp_users_2"><span class="tocnumber">3.13.8</span> <span class="toctext">Table: wp_users</span></a>
<ul>
<li class="toclevel-4"><a href="#Indexes_19"><span class="tocnumber">3.13.8.1</span> <span class="toctext">Indexes</span></a></li>
</ul>
</li>
<li class="toclevel-3"><a href="#Site_Specific_Tables"><span class="tocnumber">3.13.9</span> <span class="toctext">Site Specific Tables</span></a></li>
</ul>
</li>
</ul>
</li>
<li class="toclevel-1"><a href="#.E8.B5.84.E6.BA.90"><span class="tocnumber">4</span> <span class="toctext">资源</span></a></li>
<li class="toclevel-1"><a href="#.E6.9B.B4.E6.96.B0.E6.97.A5.E5.BF.97"><span class="tocnumber">5</span> <span class="toctext">更新日志</span></a></li>
</ul>
</td></tr></tbody></table><script type="text/javascript"> if (window.showTocToggle) { var tocShowText = "show"; var tocHideText = "hide"; showTocToggle(); } </script>
<p><br>
以下是在WordPress3.0版本标准安装过程中所创建的数据库表的大纲和描述。目前，WordPress3.0仅支持 <a href="http://codex.wordpress.org/Glossary#MySQL" title="Glossary">MySQL</a> 4.1.2及更高版本的数据库。  
</p><p>参见:
</p>
<ul><li><a href="http://codex.wordpress.org/Database_Description/2.0" title="Database Description/2.0">WordPress 2.0.x数据库描述</a>
</li><li><a href="http://codex.wordpress.org/Database_Description/2.2" title="Database Description/2.2">WordPress 2.2.x数据库描述</a>
</li><li><a href="http://codex.wordpress.org/Database_Description/2.3" title="Database Description/2.3">WordPress 2.3.x数据库描述</a>
</li><li><a href="http://codex.wordpress.org/Database_Description/2.5" title="Database Description/2.5">WordPress 2.5.x数据库描述</a>
</li><li><a href="http://codex.wordpress.org/Database_Description/2.7" title="Database Description/2.7">WordPress 2.7.x数据库描述</a>
</li><li><a href="http://codex.wordpress.org/Database_Description/2.8" title="Database Description/2.8">WordPress 2.8.x数据库描述</a>
</li><li><a href="http://codex.wordpress.org/Database_Description/2.9" title="Database Description/2.9">WordPress 2.9.x数据库描述</a>
</li></ul>
<p>由于WordPress自己与数据库接口，作为终端用户，不必过分担心它的结构。而如果你是在<a href="http://codex.wordpress.org/index.php?title=%E7%BC%96%E5%86%99%E6%8F%92%E4%BB%B6&amp;action=edit&amp;redlink=1" class="new" title="编写插件 (page does not exist)">编写插件</a>，你也许会对学习如何直接与数据库接口感兴趣。WordPress提供了<a href="http://codex.wordpress.org/Function_Reference/wpdb_Class" title="Function Reference/wpdb Class" class="mw-redirect">wpdb类</a>简化了这一过程。
</p>
<a name=".E6.95.B0.E6.8D.AE.E5.BA.93.E5.9B.BE.E8.A1.A8" id=".E6.95.B0.E6.8D.AE.E5.BA.93.E5.9B.BE.E8.A1.A8"></a><h1> <span class="mw-headline"> 数据库图表 </span></h1>
<p>下面的图表提供了一个图形化的WordPress数据库概览，以及在WordPress（WordPress2.5+）标准安装过程中创建的表之间的关系。以下的数据表概览包含了表和列的额外详细说明。
</p>
<div class="thumb tright"><div class="thumbinner" style="width:502px;"><a href="http://codex.wordpress.org/File:WP3.0-ERD.png" class="image" title="(WP 3.0 Database diagram)"><img alt="" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/500px-WP3.png" class="thumbimage" border="0" height="505" width="500"></a>  <div class="thumbcaption"><div class="magnify"><a href="http://codex.wordpress.org/File:WP3.0-ERD.png" class="internal" title="Enlarge"><img src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/magnify-clip.png" alt="" height="11" width="15"></a></div>(WP 3.0 Database diagram)</div></div></div>
<p>请注意，在wp的标准安装过程中表之间的完整性不是强制性的，比如文章和评论之间。如果你正在创建操作数据库的插件或扩展，你的代码应该做些清理工
作，以便没有无用的记录留在表里。比如当外键被删除时，使用一个SQL命令集来删除其它表中的数据(不要忘记提醒用户，在进行此类操作前进行备份)。
</p>
<a name=".E8.A1.A8.E6.A6.82.E8.BF.B0" id=".E8.A1.A8.E6.A6.82.E8.BF.B0"></a><h1> <span class="mw-headline"> 表概述 </span></h1>
<p>这一节是在wp标准安装过程中创建的所有数据表的概述。详细内容在以下各表中。
</p><p><br>
</p>
<table border="1">

<tbody><tr valign="top">
<td colspan="3"> <strong> wp2.8数据表(10)</strong>
</td></tr>
<tr valign="top">
<th width="6%"> <b>表名</b> </th><th width="35%"> <b>描述</b> </th><th> <b> WordPress用户界面相关区域</b>
</th></tr>
<tr valign="top">
<th>  <a href="#Table:_wp_comments" title="">wp_comments</a>
</th><td>  WordPress中的<b>评论</b> 存储在<tt>wp_comments</tt>表中 </td><td>评论是由读者创建的作为对文章的回应。评论由管理员管理，通过<a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Comments" title="Administration Panels" class="mw-redirect">评论</a> &gt; <a href="http://codex.wordpress.org/Comments_Comments_SubPanel" title="Comments Comments SubPanel" class="mw-redirect">评论</a>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_links" title="">wp_links</a>
</th><td> <tt>wp_links</tt> 保存包含在WordPress <a href="http://codex.wordpress.org/Administration_Panels#Links_-_Putting_the_Inter_in_the_Internet" title="Administration Panels" class="mw-redirect">Links</a> feature部分的<b>链接</b>的相关信息。 </td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Add_New_Link" title="Administration Panels" class="mw-redirect">链接</a> &gt; <a href="http://codex.wordpress.org/Links_Add_New_SubPanel" title="Links Add New SubPanel" class="mw-redirect">添加</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Edit_Links" title="Administration Panels" class="mw-redirect">链接</a> &gt; <a href="http://codex.wordpress.org/Links_Edit_SubPanel" title="Links Edit SubPanel" class="mw-redirect">编辑</a>
</li></ul>
</td></tr>
<tr valign="top">
<th>  <a href="#Table:_wp_options" title="">wp_options</a>
</th><td> <b>管理 &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">设置</a></b>面板下的<b><a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">选项</a></b>存储在<tt>wp_options</tt>表里。  </td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">设置</a> &gt; <a href="http://codex.wordpress.org/Settings_General_SubPanel" title="Settings General SubPanel" class="mw-redirect">常规</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">设置</a> &gt; <a href="http://codex.wordpress.org/Settings_Writing_SubPanel" title="Settings Writing SubPanel" class="mw-redirect">撰写</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">设置</a> &gt; <a href="http://codex.wordpress.org/Settings_Reading_SubPanel" title="Settings Reading SubPanel" class="mw-redirect">阅读</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">设置</a> &gt; <a href="http://codex.wordpress.org/Settings_Discussion_SubPanel" title="Settings Discussion SubPanel" class="mw-redirect">讨论</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">设置</a> &gt; <a href="http://codex.wordpress.org/Settings_Privacy_SubPanel" title="Settings Privacy SubPanel" class="mw-redirect">隐私</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">设置</a> &gt; <a href="http://codex.wordpress.org/Settings_Permalinks_SubPanel" title="Settings Permalinks SubPanel" class="mw-redirect">固定链接</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings_-_Configuration_Settings" title="Administration Panels" class="mw-redirect">设置</a> &gt; <a href="http://codex.wordpress.org/Settings_Miscellaneous_SubPanel" title="Settings Miscellaneous SubPanel" class="mw-redirect">杂项</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Widgets" title="Administration Panels" class="mw-redirect">外观</a> &gt; <a href="http://codex.wordpress.org/Appearance_Widgets_SubPanel" title="Appearance Widgets SubPanel" class="mw-redirect">小工具</a>
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_postmeta" title="">wp_postmeta</a>
</th><td> 每篇<b>文章</b>的特性信息被称为<b>元数据</b>，它存储在<tt>wp_postmeta</tt>. 有些插件可能会添加他们自己的信息到这个表里.   </td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Add_New_Post" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Posts_Add_New_SubPanel" title="Posts Add New SubPanel" class="mw-redirect">添加</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Add_New_Page" title="Administration Panels" class="mw-redirect">页面</a> &gt; <a href="http://codex.wordpress.org/Pages_Add_New_SubPanel" title="Pages Add New SubPanel" class="mw-redirect">添加</a>
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_posts" title="">wp_posts</a>
</th><td> 数据的核心是<b>文章</b>，它存储在<tt>wp_posts</tt>表.  </td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Add_New_Post" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Posts_Add_New_SubPanel" title="Posts Add New SubPanel" class="mw-redirect">添加</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Edit_Posts" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Posts_Edit_SubPanel" title="Posts Edit SubPanel" class="mw-redirect">编辑</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Add_New_Page" title="Administration Panels" class="mw-redirect">页面</a> &gt; <a href="http://codex.wordpress.org/Pages_Add_New_SubPanel" title="Pages Add New SubPanel" class="mw-redirect">添加</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Edit_Pages" title="Administration Panels" class="mw-redirect">页面</a> &gt; <a href="http://codex.wordpress.org/Pages_Edit_SubPanel" title="Pages Edit SubPanel" class="mw-redirect">编辑</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Upload_New_Media" title="Administration Panels" class="mw-redirect">媒体</a> &gt; <a href="http://codex.wordpress.org/Media_Add_New_SubPanel" title="Media Add New SubPanel" class="mw-redirect">添加</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Media_Library" title="Administration Panels" class="mw-redirect">媒体</a> &gt; <a href="http://codex.wordpress.org/Media_Library_SubPanel" title="Media Library SubPanel" class="mw-redirect">媒体库</a>
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_terms" title="">wp_terms</a>
</th><td> 文章和链接<b>分类</b>以及文章的tag<b>分类</b>可以在<tt>wp_terms</tt>表里找到. </td><td rowspan="3">
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Tags" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Posts_Tags_SubPanel" title="Posts Tags SubPanel" class="mw-redirect">Tags</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Categories" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Posts_Categories_SubPanel" title="Posts Categories SubPanel" class="mw-redirect">分类</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Link_Categories" title="Administration Panels" class="mw-redirect">链接</a> &gt; <a href="http://codex.wordpress.org/Links_Link_Categories_SubPanel" title="Links Link Categories SubPanel" class="mw-redirect">链接分类</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Add_New_Post" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Posts_Add_New_SubPanel" title="Posts Add New SubPanel" class="mw-redirect">添加</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Edit_Posts" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Posts_Edit_SubPanel" title="Posts Edit SubPanel" class="mw-redirect">编辑</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Add_New_Page" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Pages_Add_New_SubPanel" title="Pages Add New SubPanel" class="mw-redirect">添加</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Edit_Pages" title="Administration Panels" class="mw-redirect">文章</a> &gt; <a href="http://codex.wordpress.org/Pages_Edit_SubPanel" title="Pages Edit SubPanel" class="mw-redirect">编辑</a>
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_term_relationships" title="">wp_term_relationships</a>
</th><td> 与<b>文章</b>有关的分类、来自<tt>wp_terms</tt>表的tags以及这一关联存在于<tt>wp_term_relationships</tt>表里. <b>链接</b>与各自分类的联系也存储于这张表中.
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_term_taxonomy" title="">wp_term_taxonomy</a>
</th><td> 这张表描述了<tt>wp_terms</tt>表中每个条目的分类系统 (<b>分类</b>,<b>链接</b>,或<b>tag</b>).
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_usermeta" title="">wp_usermeta</a>
</th><td> 每个<b>用户</b>的特性信息称为<b>元数据</b>,它存储在<tt>wp_usermeta</tt>. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Users_-_Your_Blogging_Family" title="Administration Panels" class="mw-redirect">用户</a>
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_users" title="">wp_users</a>
</th><td> <b>用户</b>列表存在于<tt>wp_users</tt>表. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">管理</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Users_-_Your_Blogging_Family" title="Administration Panels" class="mw-redirect">用户</a>
</li></ul>
</td></tr></tbody></table><br><br>
<a name=".E8.A1.A8.E8.AF.A6.E7.BB.86.E8.B5.84.E6.96.99" id=".E8.A1.A8.E8.AF.A6.E7.BB.86.E8.B5.84.E6.96.99"></a><h1> <span class="mw-headline">表详细资料</span></h1>
<p>以下是在wp标准安装过程中创建的数据表每个字段的详细信息。
</p>
<a name="Table:_wp_commentmeta" id="Table:_wp_commentmeta"></a><h3> <span class="mw-headline">Table: wp_commentmeta</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>meta_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>comment_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>IND</td><td>0</td><td>FK-&gt;wp_comments.comment_id
</td></tr>
<tr>
<td>meta_key</td><td>varchar(255)</td><td>YES</td><td>IND</td><td>NULL</td><td>&nbsp;
</td></tr>
<tr>
<td>meta_value</td><td>longtext</td><td>YES</td><td>&nbsp;</td><td>NULL</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes" id="Indexes"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>0</td><td>meta_ID
</td></tr>
<tr>
<td>comment_id</td><td>INDEX</td><td>none</td><td>comment_id
</td></tr>
<tr>
<td>meta_key</td><td>INDEX</td><td>none</td><td>meta_key
</td></tr></tbody></table>
<a name="Table:_wp_comments" id="Table:_wp_comments"></a><h3> <span class="mw-headline">Table: wp_comments</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>comment_ID</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>comment_post_ID</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>IND</td><td>0</td><td>FK-&gt;wp_posts.ID
</td></tr>
<tr>
<td>comment_author</td><td>tinytext</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_author_email</td><td>varchar(100)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_author_url</td><td>varchar(200)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_author_IP</td><td>varchar(100)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_date</td><td>datetime</td><td>&nbsp;</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_date_gmt</td><td>datetime</td><td>&nbsp;</td><td>IND &amp; IND Pt2</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_content</td><td>text</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_karma</td><td>int(11)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_approved</td><td>varchar(20)</td><td>&nbsp;</td><td>IND &amp; Ind Pt1</td><td>1</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_agent</td><td>varchar(255)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_type</td><td>varchar(20)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_parent</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>FK-&gt;wp_comments.ID
</td></tr>
<tr>
<td>user_id</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>FK-&gt;wp_users.ID
</td></tr></tbody></table>
<a name="Indexes_2" id="Indexes_2"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>1</td><td>comment_ID
</td></tr>
<tr>
<td>comment_approved</td><td>INDEX</td><td>None</td><td>comment_approved
</td></tr>
<tr>
<td>comment_post_ID</td><td>INDEX</td><td>None</td><td>comment_post_ID
</td></tr>
<tr>
<td>comment_approved_date_gmt</td><td>INDEX</td><td>None</td><td>comment_approved<br>comment_date_gmt
</td></tr>
<tr>
<td>comment_date_gmt</td><td>INDEX</td><td>None</td><td>comment_date_gmt
</td></tr>
<tr>
<td>comment_parent</td><td>INDEX</td><td>None</td><td>comment_parent
</td></tr></tbody></table>
<a name="Table:_wp_links" id="Table:_wp_links"></a><h3> <span class="mw-headline">Table: wp_links</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>link_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>link_url</td><td>varchar(255)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>link_name</td><td>varchar(255)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>link_image</td><td>varchar(255)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>link_target</td><td>varchar(25)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>link_description</td><td>varchar(255)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>link_visible</td><td>varchar(20)</td><td>&nbsp;</td><td>IND</td><td>Y</td><td>&nbsp;
</td></tr>
<tr>
<td>link_owner</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>&nbsp;</td><td>1</td><td>&nbsp;
</td></tr>
<tr>
<td>link_rating</td><td>int(11)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>link_updated</td><td>datetime</td><td>&nbsp;</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>link_rel</td><td>varchar(255)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>link_notes</td><td>mediumtext</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>link_rss</td><td>varchar(255)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_3" id="Indexes_3"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>7</td><td>link_ID
</td></tr>
<tr>
<td>link_category</td><td>INDEX</td><td>None</td><td>link_category
</td></tr>
<tr>
<td>link_visible</td><td>INDEX</td><td>None</td><td>link_visible
</td></tr></tbody></table>
<a name="Table:_wp_options" id="Table:_wp_options"></a><h3> <span class="mw-headline">Table: wp_options</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>option_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI Pt1</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>blog_id</td><td>int(11)</td><td>&nbsp;</td><td>PRI Pt2</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>option_name</td><td>varchar(64)</td><td>&nbsp;</td><td>PRI Pt3 &amp; IND</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>option_value</td><td>longtext</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>
</td></tr>
<tr>
<td>autoload</td><td>varchar(20)</td><td>&nbsp;</td><td>&nbsp;</td><td>yes</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_4" id="Indexes_4"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>184</td><td>option_id<br>blog_id<br>option_name
</td></tr>
<tr>
<td>option_name</td><td>UNIQUE</td><td>184</td><td>option_name
</td></tr></tbody></table>
<a name="Table:_wp_postmeta" id="Table:_wp_postmeta"></a><h3> <span class="mw-headline">Table: wp_postmeta</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>meta_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>post_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>IND</td><td>0</td><td>FK-&gt;wp_posts.ID
</td></tr>
<tr>
<td>meta_key</td><td>varchar(255)</td><td>YES</td><td>IND</td><td>NULL</td><td>&nbsp;
</td></tr>
<tr>
<td>meta_value</td><td>longtext</td><td>YES</td><td>&nbsp;</td><td>NULL</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_5" id="Indexes_5"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>13</td><td>meta_ID
</td></tr>
<tr>
<td>post_id</td><td>INDEX</td><td>15</td><td>post_id
</td></tr>
<tr>
<td>meta_key</td><td>INDEX</td><td>7</td><td>meta_key
</td></tr></tbody></table>
<a name="Table:_wp_posts" id="Table:_wp_posts"></a><h3> <span class="mw-headline">Table: wp_posts</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>ID</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>PRI &amp; IND Pt4</td><td>&nbsp;</td><td>auto_increment
</td></tr>
<tr>
<td>post_author</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>FK-&gt;wp_users.ID
</td></tr>
<tr>
<td>post_date</td><td>datetime</td><td>&nbsp;</td><td>IND Pt3</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>post_date_gmt</td><td>datetime</td><td>&nbsp;</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>post_content</td><td>longtext</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>post_title</td><td>text</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>post_excerpt</td><td>text</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>post_status</td><td>varchar(20)</td><td>&nbsp;</td><td>IND PT2</td><td>publish</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_status</td><td>varchar(20)</td><td>&nbsp;</td><td>&nbsp;</td><td>open</td><td>&nbsp;
</td></tr>
<tr>
<td>ping_status</td><td>varchar(20)</td><td>&nbsp;</td><td>&nbsp;</td><td>open</td><td>&nbsp;
</td></tr>
<tr>
<td>post_password</td><td>varchar(20)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>post_name</td><td>varchar(200)</td><td>&nbsp;</td><td>IND</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>to_ping</td><td>text</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>pinged</td><td>text</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>post_modified</td><td>datetime</td><td>&nbsp;</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>post_modified_gmt</td><td>datetime</td><td>&nbsp;</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>post_content_filtered</td><td>text</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>
</td></tr>
<tr>
<td>post_parent</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>FK-&gt;wp_posts.ID
</td></tr>
<tr>
<td>guid</td><td>varchar(255)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>menu_order</td><td>int(11)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>post_type</td><td>varchar(20)</td><td>&nbsp;</td><td>IND Pt1</td><td>post</td><td>&nbsp;
</td></tr>
<tr>
<td>post_mime_type</td><td>varchar(100)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>comment_count</td><td>bigint(20)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_6" id="Indexes_6"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>2</td><td>ID
</td></tr>
<tr>
<td>post_name</td><td>INDEX</td><td>None</td><td>post_name
</td></tr>
<tr>
<td>type_status_date</td><td>INDEX</td><td>None</td><td>post_type<br>post_status<br>post_date<br>ID
</td></tr>
<tr>
<td>post_parent</td><td>INDEX</td><td>None</td><td>post_parent
</td></tr>
<tr>
<td>post_author</td><td>INDEX</td><td>None</td><td>post_author
</td></tr></tbody></table>
<a name="Table:_wp_terms" id="Table:_wp_terms"></a><h3> <span class="mw-headline">Table: wp_terms</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>term_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>&nbsp;</td><td>auto_increment
</td></tr>
<tr>
<td>name</td><td>varchar(200)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp; </td><td>&nbsp;
</td></tr>
<tr>
<td>slug</td><td>varchar(200)</td><td>&nbsp;</td><td>UNI</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>term_group</td><td>bigint(10)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_7" id="Indexes_7"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>2</td><td>term_ID
</td></tr>
<tr>
<td>slug</td><td>UNIQUE</td><td>2</td><td>slug
</td></tr>
<tr>
<td>name</td><td>Index</td><td>none</td><td>name
</td></tr></tbody></table>
<a name="Table:_wp_term_relationships" id="Table:_wp_term_relationships"></a><h3> <span class="mw-headline">Table: wp_term_relationships</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>object_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI Pt1</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>term_taxonomy_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI Pt2 &amp; IND</td><td>0</td><td>FK-&gt;wp_term_taxonomy.term_taxonomy_id
</td></tr>
<tr>
<td>term_order</td><td>int(11)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_8" id="Indexes_8"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>8</td><td>object_id<br>term_taxonomy_id
</td></tr>
<tr>
<td>term_taxonomy_id</td><td>INDEX</td><td>None</td><td>term_taxonomy_id
</td></tr></tbody></table>
<a name="Table:_wp_term_taxonomy" id="Table:_wp_term_taxonomy"></a><h3> <span class="mw-headline">Table: wp_term_taxonomy</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>term_taxonomy_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>&nbsp;</td><td>auto_increment
</td></tr>
<tr>
<td>term_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>UNI Pt1</td><td>0 </td><td>FK-&gt;wp_terms.term_id
</td></tr>
<tr>
<td>taxonomy</td><td>varchar(32)</td><td>&nbsp;</td><td>UNI Pt2</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>description</td><td>longtext</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>parent</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>count</td><td>bigint(20)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
</tbody></table>
<a name="Indexes_9" id="Indexes_9"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>2</td><td>term_taxonomy_id
</td></tr>
<tr>
<td>term_id_taxonomy</td><td>UNIQUE</td><td>2</td><td>term_id<br>taxonomy
</td></tr>
<tr>
<td>taxonomy</td><td>INDEX</td><td>None</td><td>taxonomy
</td></tr></tbody></table>
<a name="Table:_wp_usermeta" id="Table:_wp_usermeta"></a><h3> <span class="mw-headline">Table: wp_usermeta</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>umeta_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>user_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>&nbsp;</td><td>'0'</td><td>FK-&gt;wp_users.ID
</td></tr>
<tr>
<td>meta_key</td><td>varchar(255)</td><td>Yes</td><td>IND</td><td>NULL</td><td>&nbsp;
</td></tr>
<tr>
<td>meta_value</td><td>longtext</td><td>Yes</td><td>IND</td><td>NULL</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_10" id="Indexes_10"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>9</td><td>umeta_id
</td></tr>
<tr>
<td>user_id</td><td>INDEX</td><td>None</td><td>user_id
</td></tr>
<tr>
<td>meta_key</td><td>INDEX</td><td>None</td><td>meta_key
</td></tr></tbody></table>
<a name="Table:_wp_users" id="Table:_wp_users"></a><h3> <span class="mw-headline">Table: wp_users</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>ID</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>user_login</td><td>varchar(60)</td><td>&nbsp;</td><td>IND</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_pass</td><td>varchar(64)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_nicename</td><td>varchar(50)</td><td>&nbsp;</td><td>IND</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_email</td><td>varchar(100)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_url</td><td>varchar(100)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_registered</td><td>datetime</td><td>&nbsp;</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>user_activation_key</td><td>varchar(60)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>
</td></tr>
<tr>
<td>user_status</td><td>int(11)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>display_name</td><td>varchar(250)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp; </td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_11" id="Indexes_11"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>1</td><td>ID
</td></tr>
<tr>
<td>user_login_key</td><td>INDEX</td><td>None</td><td>user_login
</td></tr>
<tr>
<td>user_nicename</td><td>INDEX</td><td>None</td><td>user_nicename
</td></tr></tbody></table>
<a name=".E5.A4.9A.E7.AB.99.E7.82.B9.E8.A1.A8.E6.A6.82.E8.BF.B0" id=".E5.A4.9A.E7.AB.99.E7.82.B9.E8.A1.A8.E6.A6.82.E8.BF.B0"></a><h2> <span class="mw-headline">多站点表概述</span></h2>
<p>本部分是Wordpress的<a href="http://codex.wordpress.org/Glossary#Multisite" title="Glossary">Multisite</a>特性所建立的表的概述。这些表通过<a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Tools" title="Super Admin Menu" class="mw-redirect">Tools</a> &gt; <a href="http://codex.wordpress.org/Tools_Network_SubPanel" title="Tools Network SubPanel" class="mw-redirect">Network</a>下的操作建立。
</p><p>这些表被看作是全局多站点的表。
</p>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);" valign="top">
<th colspan="3"> <b>WordPress 3.0 Multisite Tables</b>
</th></tr>
<tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);" valign="top">
<th width="6%"> Table Name </th><th width="35%"> Description </th><th> Relevant Area(s) of WordPress User Interface
</th></tr>
<tr valign="top">
<th>  <a href="#Table:_wp_blogs" title="">wp_blogs</a>
</th><td> Each <b>site</b> created is stored in the table, <tt>wp_blogs</tt>. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Tools" title="Super Admin Menu" class="mw-redirect">Tools</a> &gt; <a href="http://codex.wordpress.org/Tools_Network_SubPanel" title="Tools Network SubPanel" class="mw-redirect">Network</a> 
</li><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Sites" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Sites_SubPanel" title="Super Admin Sites SubPanel" class="mw-redirect">Sites</a>  
</li></ul>
</td></tr>
<tr valign="top">
<th>  <a href="#Table:_wp_blog_versions" title="">wp_blog_versions</a>
</th><td> The current database version status of each <b>site</b> is maintained in the <tt>wp_blogs_versions</tt> table and is updated as each site is upgraded. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Update" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Update_SubPanel" title="Super Admin Update SubPanel" class="mw-redirect">Update</a> 
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_registration_log" title="">wp_registration_log</a>
</th><td> The <tt>wp_registration_log</tt> records the admin user created when each new site is created. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Sites" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Sites_SubPanel" title="Super Admin Sites SubPanel" class="mw-redirect">Sites</a>   
</li></ul>
</td></tr>
<tr valign="top">
<th>  <a href="#Table:_wp_signups" title="">wp_signups</a>
</th><td> This table holds the user that have registered for a site via the login registration process.  User registration is enable in <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Options" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Options_SubPanel" title="Super Admin Options SubPanel" class="mw-redirect">Options</a>. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Settings" title="Administration Panels" class="mw-redirect">Settings</a> &gt; <a href="http://codex.wordpress.org/Settings_General_SubPanel" title="Settings General SubPanel" class="mw-redirect">General</a>
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_site" title="">wp_site</a>
</th><td> The <tt>wp_site</tt> table contains the main site address. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Tools" title="Super Admin Menu" class="mw-redirect">Tools</a> &gt; <a href="http://codex.wordpress.org/Tools_Network_SubPanel" title="Tools Network SubPanel" class="mw-redirect">Network</a> 
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_sitecategories" title="">wp_sitecategories</a>
</th><td> If global terms (global_terms_enabled = true) are enabled for a site the <tt>wp_sitecategories</tt> table holds those terms.  </td><td>
<ul><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Options" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Options_SubPanel" title="Super Admin Options SubPanel" class="mw-redirect">Options</a>
</li><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Add_New_Post" title="Administration Panels" class="mw-redirect">Posts</a> &gt; <a href="http://codex.wordpress.org/Posts_Add_New_SubPanel" title="Posts Add New SubPanel" class="mw-redirect">Add New</a>
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_sitemeta" title="">wp_sitemeta</a>
</th><td> Each <b>site</b> features information called the <b>site data</b> and it is  stored in <tt>wp_sitemeta</tt>. Various <b>option</b> information, including the site admin is kept in this table. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Options" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Options_SubPanel" title="Super Admin Options SubPanel" class="mw-redirect">Options</a>
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_users_2" title="">wp_users</a>
</th><td> The list of all <b>users</b> is maintained in table <tt>wp_users</tt>. Multisite add two fields not in <a href="#Table:_wp_users" title="">the stand-alone version</a>.</td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Users" title="Administration Panels" class="mw-redirect">Users</a>
</li><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Super_Admin" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Users_SubPanel" title="Super Admin Users SubPanel" class="mw-redirect">Users</a>
</li><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Super_Admin" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Sites_SubPanel" title="Super Admin Sites SubPanel" class="mw-redirect">Sites</a> - Edit Site
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Table:_wp_usermeta" title="">wp_usermeta</a>
</th><td> This table is not re-create for multisite, but <b>meta data of users</b> for each site are stored in <tt>wp_usermeta</tt>. </td><td>
<ul><li> <a href="http://codex.wordpress.org/Administration_Panels" title="Administration Panels" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Administration_Panels#Users" title="Administration Panels" class="mw-redirect">Users</a>
</li><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Super_Admin" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Users_SubPanel" title="Super Admin Users SubPanel" class="mw-redirect">Users</a>
</li><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Super_Admin" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Sites_SubPanel" title="Super Admin Sites SubPanel" class="mw-redirect">Sites</a> - Edit Site
</li></ul>
</td></tr>
<tr valign="top">
<th> <a href="#Site_Specific_Tables" title="">Site Specific Tables</a>
</th><td> The data of the main site are stored in existing unnumbered 
tables. The data of additional sites are stored in new numbered tables.
</td><td>
<ul><li> <a href="http://codex.wordpress.org/Super_Admin_Menu" title="Super Admin Menu" class="mw-redirect">Administration</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Menu#Sites" title="Super Admin Menu" class="mw-redirect">Super Admin</a> &gt; <a href="http://codex.wordpress.org/Super_Admin_Sites_SubPanel" title="Super Admin Sites SubPanel" class="mw-redirect">Sites</a> - Add Site
</li></ul>
</td></tr></tbody></table><br><br>
<a name=".E5.A4.9A.E7.AB.99.E7.82.B9.E8.A1.A8.E8.AF.A6.E7.BB.86.E8.B5.84.E6.96.99" id=".E5.A4.9A.E7.AB.99.E7.82.B9.E8.A1.A8.E8.AF.A6.E7.BB.86.E8.B5.84.E6.96.99"></a><h2> <span class="mw-headline">多站点表详细资料</span></h2>
<p>The following describe the tables and fields created <a href="http://codex.wordpress.org/Create_A_Network#Step_4:_Installing_a_Network" title="Create A Network">during the network installation</a>.  Note that a global set of tables is created upon creation of the network, and <a href="#Site_Specific_Tables" title="">site-specific tables</a> are established as each site is created. 
</p>
<a name="Table:_wp_blogs" id="Table:_wp_blogs"></a><h3> <span class="mw-headline">Table: wp_blogs</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>blog_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>site_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>IND</td><td>0</td><td>
</td></tr>
<tr>
<td>domain</td><td>varchar(200)</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>path</td><td>varchar(100)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>registered</td><td>datetime</td><td>NO</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>last_updated</td><td>datetime</td><td>NO</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>public</td><td>tinyint(2)</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>archived</td><td>enum('0','1')</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>mature</td><td>tinyint(2)</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>spam</td><td>tinyint(2)</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>deleted</td><td>tinyint(2)</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>lang_id</td><td>int(11)</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_12" id="Indexes_12"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>2</td><td>blog_id
</td></tr>
<tr>
<td>domain</td><td>INDEX</td><td>none</td><td>domain(50),path(5)
</td></tr>
<tr>
<td>lang_id</td><td>INDEX</td><td>none</td><td>lang_id
</td></tr></tbody></table>
<a name="Table:_wp_blog_versions" id="Table:_wp_blog_versions"></a><h3> <span class="mw-headline">Table: wp_blog_versions</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>blog_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>0</td><td>FK-&gt;wp_blogs.blog_id
</td></tr>
<tr>
<td>db_version</td><td>varchar(20)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>last_updated</td><td>datetime</td><td>NO</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_13" id="Indexes_13"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>2</td><td>blog_id
</td></tr>
<tr>
<td>db_version</td><td>INDEX</td><td>none</td><td>db_version
</td></tr></tbody></table>
<a name="Table:_wp_registration_log" id="Table:_wp_registration_log"></a><h3> <span class="mw-headline">Table: wp_registration_log</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>ID</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>email</td><td>varchar(255)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>IP</td><td>varchar(30)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>blog_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>0</td><td>FK-&gt;wp_blogs.blog_id
</td></tr>
<tr>
<td>date_registered</td><td>datetime</td><td>NO</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_14" id="Indexes_14"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>1</td><td>ID
</td></tr>
<tr>
<td>IP</td><td>INDEX</td><td>none</td><td>IP
</td></tr></tbody></table>
<a name="Table:_wp_signups" id="Table:_wp_signups"></a><h3> <span class="mw-headline">Table: wp_signups</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>domain</td><td>varchar(200)</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>path</td><td>varchar(100)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>title</td><td>longtext</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_login</td><td>varchar(60)</td><td>NO</td><td>IND</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_email</td><td>varchar(100)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>registered_date</td><td>datetime</td><td>NO</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>activated</td><td>datetime</td><td>NO</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>active</td><td>tinyint(1)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>
</td></tr>
<tr>
<td>activation_key</td><td>varchar(50)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>meta</td><td>longtext</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp; </td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_15" id="Indexes_15"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>activation_key</td><td>INDEX</td><td>None</td><td>activation_key
</td></tr>
<tr>
<td>domain</td><td>INDEX</td><td>None</td><td>domain
</td></tr></tbody></table>
<a name="Table:_wp_site" id="Table:_wp_site"></a><h3> <span class="mw-headline">Table: wp_site</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>domain</td><td>varchar(200)</td><td>NO</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>path</td><td>varchar(100)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_16" id="Indexes_16"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>1</td><td>id
</td></tr>
<tr>
<td>domain</td><td>INDEX</td><td>none</td><td>domain,path
</td></tr></tbody></table>
<a name="Table:_wp_sitecategories" id="Table:_wp_sitecategories"></a><h3> <span class="mw-headline">Table: wp_sitecategories</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>cat_id</td><td>bigint(20)  unsigned</td><td>NO</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>cat_name</td><td>carchar(55)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>category_nicename</td><td>varchar(200)</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>last_updated</td><td>timestamp</td><td>NO</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_17" id="Indexes_17"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>9</td><td>cat_id
</td></tr>
<tr>
<td>category_nicename</td><td>INDEX</td><td>None</td><td>category_nicename
</td></tr>
<tr>
<td>last_updated</td><td>INDEX</td><td>None</td><td>last_updated
</td></tr></tbody></table>
<a name="Table:_wp_sitemeta" id="Table:_wp_sitemeta"></a><h3> <span class="mw-headline">Table: wp_sitemeta</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>meta_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>site_id</td><td>bigint(20)  unsigned</td><td>&nbsp;</td><td>&nbsp;</td><td>'0'</td><td>FK-&gt;wp_site.site_id
</td></tr>
<tr>
<td>meta_key</td><td>varchar(255)</td><td>Yes</td><td>IND</td><td>NULL</td><td>&nbsp;
</td></tr>
<tr>
<td>meta_value</td><td>longtext</td><td>Yes</td><td>IND</td><td>NULL</td><td>&nbsp;
</td></tr></tbody></table>
<a name="Indexes_18" id="Indexes_18"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>9</td><td>meta_id
</td></tr>
<tr>
<td>meta_key</td><td>INDEX</td><td>None</td><td>meta_key
</td></tr>
<tr>
<td>site_id</td><td>INDEX</td><td>None</td><td>site_id
</td></tr></tbody></table>
<a name="Table:_wp_users_2" id="Table:_wp_users_2"></a><h3> <span class="mw-headline">Table: wp_users</span></h3>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Field</th><th>Type</th><th>Null</th><th>Key</th><th>Default</th><th>Extra
</th></tr>
<tr>
<td>ID</td><td>bigint(20) unsigned</td><td>&nbsp;</td><td>PRI</td><td>NULL</td><td>auto_increment
</td></tr>
<tr>
<td>user_login</td><td>varchar(60)</td><td>&nbsp;</td><td>IND</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_pass</td><td>varchar(64)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_nicename</td><td>varchar(50)</td><td>&nbsp;</td><td>IND</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_email</td><td>varchar(100)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_url</td><td>varchar(100)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;
</td></tr>
<tr>
<td>user_registered</td><td>datetime</td><td>&nbsp;</td><td>&nbsp;</td><td>0000-00-00 00:00:00</td><td>&nbsp;
</td></tr>
<tr>
<td>user_activation_key</td><td>varchar(60)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>
</td></tr>
<tr>
<td>user_status</td><td>int(11)</td><td>&nbsp;</td><td>&nbsp;</td><td>0</td><td>&nbsp;
</td></tr>
<tr>
<td>display_name</td><td>varchar(250)</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp; </td><td>&nbsp;
</td></tr>
<tr>
<td>spam</td><td>tinyint(2)</td><td>NO</td><td>&nbsp;</td><td> 0 </td><td>
</td></tr>
<tr>
<td>deleted</td><td>tinyint(2)</td><td>NO</td><td>&nbsp;</td><td> 0 </td><td>
</td></tr></tbody></table>
<a name="Indexes_19" id="Indexes_19"></a><h4> <span class="mw-headline">Indexes</span></h4>
<table class="widefat">

<tbody><tr style="background: none repeat scroll 0% 0% rgb(70, 70, 70); color: rgb(215, 215, 215);">
<th>Keyname</th><th>Type</th><th>Cardinality</th><th> Field
</th></tr>
<tr>
<td>PRIMARY</td><td>PRIMARY</td><td>1</td><td>ID
</td></tr>
<tr>
<td>user_login_key</td><td>INDEX</td><td>None</td><td>user_login
</td></tr>
<tr>
<td>user_nicename</td><td>INDEX</td><td>None</td><td>user_nicename
</td></tr></tbody></table>
<a name="Site_Specific_Tables" id="Site_Specific_Tables"></a><h3> <span class="mw-headline">Site Specific Tables</span></h3>
<p>When a new additional site is created, the site-specific tables, similar to <a href="#Table_Overview" title="">the stand-alone tables above</a>, are created. Each set of tables for a site are created with the site ID (<a href="#Table:_wp_blogs" title=""><code>blog_id</code></a>) as part of the table name.  These are the tables that would be created for site ID <i>2</i> and <a href="http://codex.wordpress.org/Editing_wp-config.php#table_prefix" title="Editing wp-config.php">table_prefix</a> <i>wp</i>:
</p>
<ul><li> <a href="#Table:_wp_commentmeta" title=""><i>wp_2</i>_commentmeta</a>
</li><li> <a href="#Table:_wp_comments" title=""><i>wp_2</i>_comments</a>
</li><li> <a href="#Table:_wp_links" title=""><i>wp_2</i>_links</a>
</li><li> <a href="#Table:_wp_options" title=""><i>wp_2</i>_options</a>
</li><li> <a href="#Table:_wp_postmeta" title=""><i>wp_2</i>_postmeta</a>
</li><li> <a href="#Table:_wp_posts" title=""><i>wp_2</i>_posts</a>
</li><li> <a href="#Table:_wp_terms" title=""><i>wp_2</i>_terms</a>
</li><li> <a href="#Table:_wp_term_relationships" title=""><i>wp_2</i>_term_relationships</a>
</li><li> <a href="#Table:_wp_term_taxonomy" title=""><i>wp_2</i>_term_taxonomy</a>
</li></ul>
<p>The data of the main site are stored in unnumbered tables.
</p>
<a name=".E8.B5.84.E6.BA.90" id=".E8.B5.84.E6.BA.90"></a><h1> <span class="mw-headline"> 资源 </span></h1>
<ul><li><a href="http://wpbits.wordpress.com/2007/08/08/a-look-inside-the-wordpress-database/" class="external text" title="http://wpbits.wordpress.com/2007/08/08/a-look-inside-the-wordpress-database/">A look inside the WordPress database</a> 一篇Leonid Mamchenkov 的关于数据库表的深入探讨. 
</li></ul>
<a name=".E6.9B.B4.E6.96.B0.E6.97.A5.E5.BF.97" id=".E6.9B.B4.E6.96.B0.E6.97.A5.E5.BF.97"></a><h1> <span class="mw-headline"> 更新日志 </span></h1>
<ul><li> <a href="http://codex.wordpress.org/Version_3.0" title="Version 3.0">3.0</a>&nbsp;: 
<ul><li> <a href="#Table:_wp_comments" title="">comments table</a>: 增加<code>comment_parent</code>索引.
</li><li> <a href="#Table:_wp_posts" title="">posts table</a>: 增加<code>post_author</code>索引.
</li><li> 开启<a href="http://codex.wordpress.org/Glossary#Multisite" title="Glossary">Multisite</a>特性时:
<ul><li> 增加<a href="#Multisite_Table_Overview" title="">multisite tables</a>.
</li><li> 增加<code>spam</code>和<code>deleted</code>字段到<a href="#Table:_wp_users_2" title="">users table</a>.
</li></ul>
</li></ul>
</li></ul>
<ul><li> <a href="http://codex.wordpress.org/Version_2.9" title="Version 2.9">2.9</a>&nbsp;: 
<ul><li> <a href="#Table:_wp_commentmeta" title="">commentmeta table</a>: 用于存储评论相关的数据.
</li><li> <a href="#Table:_wp_option" title="">options table</a>: 增加唯一索引<code>option_name</code>.
</li><li> <a href="http://schemabank.com/p/5Lj5F" class="external text" title="http://schemabank.com/p/5Lj5F">更新了数据库图表</a>
</li></ul>
</li></ul>
<ul><li> <a href="http://codex.wordpress.org/Version_2.8" title="Version 2.8">2.8</a>&nbsp;: 
<ul><li> <a href="#Table:_wp_comments" title="">comments table</a>&nbsp;: 修改 <code>comment_post_ID</code> 列为 bigint(20), unsigned.
</li><li> <a href="#Table:_wp_links" title="">links table</a>&nbsp;: 删除 <code>link_category</code> 列.
</li><li> <a href="#Table:_wp_posts" title="">posts table</a>: 删除 <code>post_category</code> 列.
</li><li> <a href="#Table:_wp_term_taxonomy" title="">term_taxonomy table</a>:添加键 <code>taxonomy</code>.
</li><li> 添加 unsigned 属性到类型为 bigint(20) 的字段.
</li></ul>
</li><li> <a href="http://codex.wordpress.org/Version_2.7" title="Version 2.7">2.7</a>&nbsp;: 
<ul><li> <a href="#Table:_wp_terms" title="">term table</a>&nbsp;: 修改 <code>name</code> 字段 <code>varchar(55)</code> -&gt; <code>varchar(200)</code>.
</li><li> 添加键 <code>name</code> 到 <a href="#Table:_wp_terms" title="">term table</a>.
</li><li> 添加键 <code>post_parent</code> 到 <a href="#Table:_wp_posts" title="">posts table</a>.
</li></ul>
</li><li> <a href="http://codex.wordpress.org/Version_2.5" title="Version 2.5">2.5</a>&nbsp;: 
<ul><li> 所有 <code>enum</code> 类型字段改为 <code>varchar(20)</code>:
<ul><li> <a href="#Table:_wp_comments" title="">comments table</a>： <code>comment_approved</code> field
</li><li> <a href="#Table:_wp_links" title="">links table</a>： <code>link_visible</code>
</li><li> <a href="#Table:_wp_options" title="">options table</a>： <code>autoload</code>
</li><li> <a href="#Table:_wp_posts" title="">posts table</a>: <code>post_status</code>, <code>comment_status</code>, <code>ping_status</code>
</li></ul>
</li><li> 添加键 <code>comment_approved_date_gmt</code> 和 <code>comment_date_gmt</code> 到 <a href="#Table:_wp_comments" title="">comments table</a>.
</li><li> 添加 <code>term_order</code> 字段到 <a href="#Table:_term_relationships" title="">term_relationships table</a>
</li><li> 参见: <a href="http://codex.wordpress.org/Migrating_Plugins_and_Themes_to_2.5#Database_changes" title="Migrating Plugins and Themes to 2.5">Migrating Plugins and Themes to 2.5 - Database changes</a>
</li></ul>
</li><li> <a href="http://codex.wordpress.org/Version_2.3" title="Version 2.3">2.3</a>&nbsp;:
<ul><li> 添加 <a href="#Table:_wp_terms" title="">terms</a>, <a href="#Table:_wp_term_taxonomy" title="">term_taxonomy</a> and <a href="#Table:_wp_term_relationships" title="">term_relationships</a> 表. 删除 <code>categories</code>, <code>link2cat</code>和 <code>post2cat</code>表.
</li><li> 删除 <a href="#Table:_wp_options" title="">options table</a>中的6个字段. (<code>option_can_override</code>, <code>option_type</code>, <code>option_width</code>, <code>option_height</code>, <code>option_description</code>, and <code>option_admin_level</code>)
</li><li> 添加新状态 <code>'pending'</code>到<a href="#Table:_wp_posts" title="">posts table</a>的<code>post_status</code>字段.
</li><li> 参见: <a href="http://codex.wordpress.org/WordPress_Taxonomy" title="WordPress Taxonomy">WordPress Taxonomy</a>
</li></ul>
</li><li> <a href="http://codex.wordpress.org/Version_2.1" title="Version 2.1">2.1</a>&nbsp;:
<ul><li> 删除<code>linkcategories</code>表. 链接分类数据合并到<code>categories</code>表, 重设IDs.
</li><li> 添加<code>post_type</code>字段到<a href="#Table:_wp_posts" title="">posts table</a> (in 2.0.x, <code>post_status</code> = <code>'static'</code> for <a href="http://codex.wordpress.org/Pages" title="Pages">Pages</a>)
</li><li> 添加新状态 <code>'future'</code> <a href="#Table:_wp_posts" title="">posts table</a>的 <code>post_status</code>字段 , 代替2.0.x版本中的 <code>NOW()</code>.
</li><li> 参见： <a href="http://codex.wordpress.org/Migrating_Plugins_and_Themes_to_2.1#Core_WordPress_Database_Changes" title="Migrating Plugins and Themes to 2.1">Migrating Plugins and Themes to 2.1 - Core WordPress Database Changes</a>
</li></ul>
</li></ul>

<!-- 
NewPP limit report
Preprocessor node count: 84/1000000
Post-expand include size: 777/2097152 bytes
Template argument size: 263/2097152 bytes
Expensive parser function count: 0/100
-->
<div class="printfooter">
Retrieved from "<a href="http://codex.wordpress.org/zh-cn:%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0">http://codex.wordpress.org/zh-cn:%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0</a>"</div>
				<div id="catlinks"><div id="catlinks" class="catlinks"><div id="mw-normal-catlinks"><a href="http://codex.wordpress.org/Special:Categories" title="Special:Categories">Categories</a>: <span dir="ltr"><a href="http://codex.wordpress.org/Category:Getting_Started" title="Category:Getting Started">Getting Started</a></span> | <span dir="ltr"><a href="http://codex.wordpress.org/Category:Advanced_Topics" title="Category:Advanced Topics">Advanced Topics</a></span> | <span dir="ltr"><a href="http://codex.wordpress.org/Category:WordPress_Development" title="Category:WordPress Development">WordPress Development</a></span></div></div></div>			<!-- end content -->
		</div>
		<div class="col-2">
			
						
			<ul class="submenu">
				<li id="n-mainpage"><a href="http://codex.wordpress.org/Main_Page">Home Page</a></li>	
				<li><a href="http://codex.wordpress.org/WordPress_Lessons">WordPress Lessons</a></li>
				<li><a href="http://codex.wordpress.org/Getting_Started_with_WordPress">Getting Started</a></li>
				<li><a href="http://codex.wordpress.org/Working_with_WordPress">Working with WordPress</a></li>
				<li><a href="http://codex.wordpress.org/Blog_Design_and_Layout">Design and Layout</a></li>
				<li><a href="http://codex.wordpress.org/Advanced_Topics">Advanced Topics</a></li>
				<li><a href="http://codex.wordpress.org/Troubleshooting">Troubleshooting</a></li>
				<li><a href="http://codex.wordpress.org/Developer_Documentation">Developer Docs</a></li>
				<li><a href="http://codex.wordpress.org/About_WordPress">About WordPress</a></li>
			</ul>

			<h3>Codex Resources</h3>
			<ul class="submenu">
				<li id="n-portal"><a href="http://codex.wordpress.org/Codex:Community_Portal">Community portal</a></li>	      
				<li id="n-currentevents"><a href="http://codex.wordpress.org/Current_events">Current events</a></li>	      
				<li id="n-recentchanges"><a href="http://codex.wordpress.org/Special:RecentChanges">Recent changes</a></li>	      
				<li id="n-randompage"><a href="http://codex.wordpress.org/Special:Random">Random page</a></li>	      
				<li id="n-help"><a href="http://codex.wordpress.org/Help:Contents">Help</a></li>	
			</ul>
			
		</div>
	</div>
</div>


<div id="footer">
	<div class="wrapper">
		<p> 
			<a href="http://wordpress.org/about/privacy/">Privacy</a> | 
			<a href="http://wordpress.org/about/license/">License / GPLv2</a>
            &nbsp; &nbsp; See also: 
            <a href="http://wordpress.com/?ref=wporg-footer" title="Hassle-free WP hosting">WordPress.com</a> |
			<a href="http://wordpress.tv/" title="Videos, tutorials, WordCamps">WordPress.TV</a> |
			<a href="http://central.wordcamp.org/" title="Find a WordPress event near your home">WordCamp</a> |
			<a href="http://jobs.wordpress.net/" title="Find or post WordPress jobs">WP Jobs</a> | 
            <a href="http://ma.tt/" title="Co-founder of WordPress, an example of what WordPress can do">Matt</a> |
			<a href="http://wordpress.org/news/feed/" class="rsslink">Blog RSS</a>
		</p>
<br>
<iframe src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/like.xhtml" style="border: medium none; overflow: hidden; width: 150px; height: 21px;" allowtransparency="true" frameborder="0" scrolling="no"></iframe>
<div style="height: 20px; width: 90px; display: inline-block; text-indent: 0pt; margin: 0pt; padding: 0pt; background: none repeat scroll 0% 0% transparent; border-style: none; float: none; line-height: normal; font-size: 1px; vertical-align: baseline;" id="___plusone_0"><iframe allowtransparency="true" hspace="0" id="I1_1330958754816" marginheight="0" marginwidth="0" name="I1_1330958754816" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/fastbutton.htm" style="position: absolute; left: -10000px; top: -10000px; width: 90px; margin: 0px; border-style: none;" tabindex="-1" vspace="0" title="+1" frameborder="0" scrolling="no" width="100%"></iframe></div>
<iframe allowtransparency="true" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/follow_button.xhtml" style="width: 150px; height: 20px;" frameborder="0" scrolling="no"></iframe>

		<h6>Code is Poetry</h6>
	</div>
</div>


<script type="text/javascript">_qoptions={qacct:"p-18-mFEk4J448M"};</script>
<script type="text/javascript" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/quant.js"></script>
<noscript><img src="http://pixel.quantserve.com/pixel/p-18-mFEk4J448M.gif" style="display: none;" border="0" height="1" width="1" alt=""/></noscript>
<!--  -->
<script type="text/javascript" src="zh-cn%20%E6%95%B0%E6%8D%AE%E5%BA%93%E6%8F%8F%E8%BF%B0_files/gprofiles.js"></script>
<script type="text/javascript">
  (function() {
    var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
    po.src = 'https://apis.google.com/js/plusone.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
  })();
</script>
<script type="text/javascript">
(function($){
$(document).ready(function() {
	$('#footer a').click(function() {
		if (this.href.indexOf('wordpress.org') == -1 && this.href.indexOf('http') == 0) {
			recordOutboundLink(this, 'Outbound Links', this.href);
			return false;
		}
	});
});
})(jQuery);
</script>








</body><!-- Cached 20120127004915 --><!-- Cached 20120127004915 --></html>